alter table

For example , to enable this feature , you could use the ALTER TABLE

例如，为了启用该特性，可以使用ALTERTABLE

To turn a table into a compressed table , use alter table

为了将一个表转换成压缩表，可以使用altertable

Columns can be renamed online using the ALTER TABLE statement .

使用ALTERTABLE语句在线重命名列。

Alter table test drop come ;

当前表丢弃一个字段；

According to this sample , the following steps will be executed by ALTER TABLE statements

对于这个示例，ALTERTABLE语句将执行以下步骤

The second algorithm is used when the table is placed in APPEND mode through ALTER TABLE .

当表是通过ALTERTABLE以APPEND模式放置时，就要使用第二种算法。

You can create a table WITH AUDIT clause or alter table ADD | DROP AUDIT clause .

您可以创建一个表格WITHAUDIT子句，或者改变表格ADDDROPAUDIT子句。

Note , however , that the ALTER TABLE statement only allows you to increase the inline length .

但是要注意，ALTERTABLE语句只允许增加inlinelength。

Your database user needs quite a lot database permissions , including alter table , drop table , same for index etc.

数据库用户需要相当多的权限，包括修改表格，放下表格，索引一类的也一样。

Grant alter table to tea ;

给用户更改表的权限。

The following example demonstrates how to rename a column using the ALTER TABLE command while keeping the table fully accessible

下面的示例演示了如何使用ALTERTABLE命令重命名一个列，同时保持表具有完整的可访问性

First the ALTER TABLE ATTACH PARTITION command incorporates an existing table into a partitioned table as a new data partition .

首先，利用命令ALTERTABLEATTACHPARTITION，以新数据分区的方式，将现有的表合并到已分区表中。

Note : A reorganization of the tables is necessary , the ALTER TABLE statement just updates the catalog content .

注意：表的重组是必需的，ALTERTABLE语句只是更新编目的内容。

The statements at B and C show only the col1 column because the ALTER TABLE statement has been rolled back .

标签B和C的语句仅显示col1列，因为ALTERTABLE语句被回滚了。

In combination with enhancements to the ALTER TABLE statement , a convenient way for managing different versions of a database solution was created .

再结合使用对ALTERTABLE语句的改进，就可以方便地管理数据库解决方案的不同版本。

Alter table emp disable all triggers .

禁止或激活表的所有触发器。

Some operations like ALTER TABLE require no cursor to be open , while others like CREATE INDEX ONLINE allow cursors on the table .

ALTERTABLE等一些操作要求不打开游标，而CREATEINDEXONLINE等其它操作则允许表上的游标。

Use the LOCKSIZE parameter of the ALTER TABLE statement to control how locking is done for a specific table on a permanent basis .

使用altERTABLE语句的LOCKSIZE参数控制如何在持久基础上对某个特定表进行锁定。

This can be added to existing tables using the ALTER TABLE statement , or the row change timestamp column can defined when creating a new table .

这可以通过ALTERTABLE语句添加到现有表，或者在创建新表时定义行修改时间戳列。

The script below will scan for AW fact tables named using the wildcard expression % _MEASURES and scripts ALTER TABLE and REORG commands .

以下脚本将使用通配符表达式%MEASURES以及脚本ALTERTABLE和REORG命令扫描指定的AW事实表。

Thus , if you wanted to add an empty partition to a partitioned table named SALES , you could do so by executing an ALTER TABLE statement similar to this

这样，如果您想添加一个分区表名为SALES的空分区，可以执行一个与下面类似的ALTERTABLE语句

A new , empty partition can be added to a partitioned table by executing the ALTER TABLE statement with the ADD PARTITION option specified ; the syntax used looks like this

可以通过执行ALTERTABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区，使用的语法如下所示

When there are no dependent materialized query tables ( MQT ), the system initiates the second phase after the first phase ( ALTER TABLE DETACH PARTITION ) commits .

当不存在依赖的物化查询表（MQT）时，系统在完成第一阶段（ALTERTABLEDETACHPARTITION）的提交后，启动第二阶段。

But for module upgrades from module versions with older table structures , you need to add a tiny bit of module upgrade code to instruct it when to execute the ALTER TABLE code .

但对于具有旧的表结构模块的升级，你需要添加一点模块升级代码来进行指导，以执行ALTERTABLE代码。

You can easily attach and detach the partitions using the DB2 alter table command to move the data from one table ( production table ) to another table ( history table ) in the same database .

您可以很容易使用DB2altertable命令来附加和分离分区，从而将数据从一个表（生产表）移动到同一个数据库的另一个表（历史表）中。

Some are related to performance and scalability , such as data row compression , and some are related to manageability , such as the ability to copy database schema , and ALTER TABLE statement enhancements .

其中一些特性与性能和可伸缩性有关，例如数据行压缩，而另外一些则与可管理性有关，例如复制数据库模式的功能，以及ALTERTABLE语句增强。

You can use ALTER TABLE with the DROP VERSIONING clause for the same purpose , but IBM suggests sparse use of DROP VERSIONING because it can cause invalidation , which should be avoided if possible .

您可以使用ALTERTABLE和DROPVERSIONING子句实现相同用途，但IBM建议尽量少使用DROPVERSIONING，因为它可能导致无效性，这应该尽可能避免。

So , if you wanted to attach a base table named Q4_2010_SALES to an existing partitioned table named SALES as a new partition , you could do so by executing an ALTER TABLE statement that looks like this

因此，如果您想将一个名为Q42010SALES的基表作为新分区添加到一个名为SALES的现有分区表，可以执行一个如下所示的ALTERTABLE语句

If having a clustered index is needed , its effect on inserts can be minimized by ensuring that sufficient free space exists : use ALTER TABLE to increase PCTFREE , then REORG to reserve the free space .

如果的确需要群集索引，那么可以通过确保有足够的自由空间来使其对插入的影响降至最小：使用ALTERTABLE增加PCTFREE，然后使用REORG预留自由空间。

Ability to alter a table by modifying the script .

能够通过修改脚本更改表。